﻿<Window x:Class="ExcelToSql.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="ExcelToSQL" Height="358.861" Width="847.31" Loaded="Window_Loaded">
    <Grid>
        <TabControl Name="tabControl">
            <TabItem Header="ConnectionManager">
                <Grid>
                    <Label Content="Default ConnectionString:" HorizontalAlignment="Left" Margin="10,10,0,0" VerticalAlignment="Top" FontWeight="Bold"/>
                    <TextBox x:Name="textBoxConnectionString" HorizontalAlignment="Left" Height="23" Margin="10,36,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="476" Text="{Binding ConnectionStringDefault, Source={StaticResource MyConnectionManagerBinding}}"/>
                    <Label Content="Folder:" HorizontalAlignment="Left" Margin="10,64,0,0" VerticalAlignment="Top" FontWeight="Bold"/>
                    <TextBox x:Name="textBoxFolder" HorizontalAlignment="Left" Height="23" Margin="10,90,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="476" Text="{Binding Folder, Source={StaticResource MyConnectionManagerBinding}}"/>
                    <Label Content="Prefix:" HorizontalAlignment="Left" Margin="10,113,0,0" VerticalAlignment="Top" FontWeight="Bold"/>
                    <TextBox x:Name="textBoxPrefix" HorizontalAlignment="Left" Height="23" Margin="10,139,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="476" Text="{Binding Prefix, Source={StaticResource MyConnectionManagerBinding}}"/>
                    <Button Content="..." HorizontalAlignment="Left" Margin="491,91,0,0" VerticalAlignment="Top" Width="25" Click="Button_Click"/>
                    <TextBlock Text="Default database ConnectionString." HorizontalAlignment="Left" Margin="605,36,0,0" VerticalAlignment="Top" Height="54" Width="214"/>
                    <TextBlock Text="Folder and Subfolders in which to search Excel files (*.xlsx)." HorizontalAlignment="Left" Margin="605,90,0,0" VerticalAlignment="Top" Height="49" Width="214" TextWrapping="Wrap" />
                    <TextBlock Text="Create database tables and views with this prefix ." HorizontalAlignment="Left" Margin="605,139,0,0" VerticalAlignment="Top" Height="49" Width="214" TextWrapping="Wrap" />

                </Grid>
            </TabItem>
            <TabItem Header="ExcelToSql" Name="tabItemMain">
                <Grid>
                    <TextBlock Height="44" HorizontalAlignment="Left" Margin="6,6,0,0" x:Name="textBlock" Text="Load local Excel (*.xlsx) files to SQL databse." VerticalAlignment="Top" Width="337" TextWrapping="Wrap" FontWeight="Bold" />
                    <Button Content="Run" Height="23" HorizontalAlignment="Right" Margin="0,36,90,0" Name="buttonRun" VerticalAlignment="Top" Width="75" Background="#5800E500" Click="buttonRun_Click"></Button>
                    <TextBox Margin="6,64,6,6" Name="textBoxLog" FontFamily="Courier New" HorizontalScrollBarVisibility="Visible" VerticalScrollBarVisibility="Visible" />
                    <ComboBox Height="23" HorizontalAlignment="Left" Margin="372,36,0,0" Name="comboBoxConnectionString" VerticalAlignment="Top" Width="186" ItemsSource="{Binding ConnectionStringList, Source={StaticResource MyConnectionManagerBinding}}" SelectedIndex="{Binding ConnectionStringListIndex, Mode=TwoWay, Source={StaticResource MyConnectionManagerBinding}}"/>
                    <Label Content="ConnectionString:" HorizontalAlignment="Left" Margin="372,10,0,0" Name="label" VerticalAlignment="Top" />
                    <Button Content="Drop" Height="23" HorizontalAlignment="Right" Margin="0,36,10,0" x:Name="buttonDrop" VerticalAlignment="Top" Width="75" Background="#590000FF" Click="buttonDrop_Click" />
                </Grid>
            </TabItem>
        </TabControl>
    </Grid>
</Window>
